package com.sgolub.commanndsonline.domain.ref.distinct;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedNativeQuery;


@Entity
@NamedNativeQuery(name = "findDistinctRegions", 
				  query = "select region_name from \"DIST_REGIONS\" " +
				  		"where upper(region_name) like upper(:paramMatchString) " +
				  		"order by region_name", 
				  resultClass = RefDistinctRegion.class)
public class RefDistinctRegion {
//
//	@Id
//    @Column(name = "REGION_COD")
//    private String regionCod;
    
	@Id
    @Column(name = "REGION_NAME")
    private String regionName;

//	public String getRegionCod() {
//		return regionCod;
//	}
//
//	public void setRegionCod(String regionCod) {
//		this.regionCod = regionCod;
//	}

	public String getRegionName() {
		return regionName;
	}

	public void setRegionName(String regionName) {
		this.regionName = regionName;
	}


    
    
    
	
}
